MySql Installation

===========================
MySql INSTALLATION
===========================
[root@]# wget http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/centos/5.0/MySQL-bench-5.0.27-0.glibc23.i386.rpm
[root@]# wget http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/centos/5.0/MySQL-client-5.0.27-0.glibc23.i386.rpm
[root@]# wget http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/centos/5.0/MySQL-devel-5.0.27-0.glibc23.i386.rpm
[root@]# wget http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/centos/5.0/MySQL-server-5.0.27-0.glibc23.i386.rpm
[root@]# wget http://httpupdate.cpanel.net/mysqlinstall/5.0.27-0/centos/5.0/MySQL-shared-5.0.27-0.glibc23.i386.rpm
[root@]# wget http://mirror.centos.org/centos-5/5/os/i386/CentOS/perl-DBI-1.52-1.fc6.i386.rpm
[root@]# rpm -ivh perl-DBI-1.52-1.fc6.i386.rpm
[root@]# rpm -ivh MySQL-bench-5.0.27-0.glibc23.i386.rpm
[root@]# rpm -ivh MySQL-client-5.0.27-0.glibc23.i386.rpm
[root@]# rpm -ivh MySQL-devel-5.0.27-0.glibc23.i386.rpm
[root@]# rpm -ivh MySQL-server-5.0.27-0.glibc23.i386.rpm
[root@]# rpm -ivh MySQL-shared-5.0.27-0.glibc23.i386.rpm
The following is what I did to change the data directory after using RPM to install.
1. stop mysql server
2. mkdir /home/mysql
3. mv /var/lib/mysql/* /home/mysql/
4. rmdir /var/lib/mysql
5. ln -s /home/mysql /var/lib/mysql
6. chown -R mysql:mysql /home/mysql
7. start mysql server again
================================